home *** CD-ROM | disk | FTP | other *** search
;; PSPad code template for MySQL ;; Author: Karel Pavelka ;; E-mail: webjob@seznam.cz ;; Update: 02.10.2003 ;; ;; (black) ;; B (blue) ;; D (dark gray) ;; F (fuchsia) ;; G (green) ;; M (maroon) ;; N (navy) Kusy kodu ;; P (purple) ;; R (red) ;; ;; Odsazeni: 4 ;; Puvodni autor: Ing. Jan Fiala E-mail: pspad@wo.cz ; [Macro definition] %autoincrement%=@K auto increment,,,, %count%=@E poΦet,,,, %datep%=@E datum,,,,' %default%=@E default,,,, %DELAYED%=@K DELAYED,DELAYED,,, %dformat%=@E formßt,,%,,' %expr%=@E v²raz,,,, %expr1%=@E v²raz 1,,,, %expr2%=@E v²raz 2,,,, %expr3%=@E v²raz 3,,,, %file%=@O v²raz,,,, %helpSF%=@C N┴POV╠DA-nevypl≥ovat!,,,;"%M Anglick² nßzev m∞sφce";"%m ╚φslo m∞sφce";"%b Zkratka anglickΘho nßzvu m∞sφce";"%W Anglick² nßzev dne";"%D Den v m∞sφci";"%Y Rok 4mφstn²";"%y Rok 2mφstn²";"%j Den v roce Φφseln² (001)";"%a Zkrßcen² anglick² nßzev dne v t²dnu";"%d ╚φselnß podoba dne v m∞sφci";"%r ╚as 12hodinov²";"%T ╚as 24hodinov²";"%H Hodina 00-23";"%h Hodina 01-12";"%i Minuty 00-59";"%S Sekundy 00-59", %IFEXISTS%=@K IF EXISTS,IF EXISTS,,, %IFNOTEXISTS%=@K IF NOT EXISTS,IF NOT EXISTS,,, %IGNORE%=@K IGNORE,IGNORE,,, %interval%=@C v²raz intervalu,,,YEAR;DAY;HOUR;MINUTE;SECOND, %INTO%=@K INTO,INTO,,, %lenght%=@E dΘlka,,,, %LOWPRIORITY%=@K LOW_PRIORITY,LOW_PRIORITY,,, %namec%=@E nßzev sloupce,,,, %namec1%=@E nßzev sloupce1,,,, %namec2%=@E nßzev sloupce2,,,, %named%=@E nßzev databßze,,,, %namei%=@E nßzev indexu,,,, %nament%=@E nßzev novΘ tabulky,,,, %nament2%=@E nßzev 2 novΘ tabulky,,,, %namep%=@E nßzev pole,,,, %namet%=@E nßzev tabulky,,,, %namet2%=@E nßzev 2 tabulky,,,, %null%=@C null,,,"NOT NULL";NULL, %seconds%=@E sekundy,,,, %start%=@C start,,,", 1";", 0", %TEMPORARY%=@K TEMPORARY,TEMPORARY,,, %time%=@E Φas,,,,' %type%=@C datov² typ,,,,BIGINT;BLOB;DATE;DATETIME;DECIMAL;DOUBLE;ENUM();FLOAT();CHAR();INT();LONGBLOB;LONGTEXT;MEDIUMBLOB;MEDIUMINT;MEDIUMTEXT;SET();SMALLINT();TEXT;TIME;TIMESTAMP();TINYBLOB;TINYINT();TINYTEXT;VARCHAR();YEAR, %typee%=@C hodnota,,,SECOND;MINUTE;HOUR;DAY;MONTH;YEAR;MINUTE_SECOND;HOUR_MINUTE;DAY_HOUR;YEAR_MONTH;HOUR_SECOND;DAY_MINUTE;DAY_SECOND, %WHERE%=@K WHERE,WHERE,,, %whered%=@E WHERE definice,,,,' %x%=@E argument X,,,, %y%=@E argument Y,,,, %z%=@E argument Z,,,, ; ; [ABS | vracφ absolutnφ hodnotu Φφsla; to znamenß, ₧e ze zßporn²ch Φφsel odstra≥uje znamΘnko mφnus] ABS(|º) ; [ACOS | vracφ kosinus zadanΘ hodnoty. Nenφ-li hodnota mezi -1 a 1, vracφ prßzdnou hodnotu (NULL)] ACOS(|º) ; [ADDDATE | vracφ souΦet data a v²razu intervalu] ADDDATE(date,INTERVAL expr type) ; [ALTER TABLE | zm∞nit tabulku...] ALTER %IGNORE% TABLE %namet% alter_spec [, alter_spec ...] ; [ASCII | vracφ k≤d ASCII prvnφho znaku v danΘm °et∞zci] ASCII("|º") ; [ASIN | vracφ sinus zadanΘho argumentu. Nenφ-li hodnota mezi -1 a 1, vracφ prßzdnou hodnotu (NULL)] ASIN(|º) ; [ATAN | vracφ tangentu zadanΘho argumentu] ATAN(|º) ; [ATAN2 | vracφ tangentu zalo₧enou na znamΘnku p°edanΘm v argumentech, kterΘ oznaΦujφ kvadrant] ATAN2(%x%, %y%)º ; [AVG | vracφ pr∙m∞r hodnot urΦen²ch v²razem a p°edan²ch prost°ednictvφm argumentu] AVG(|º) ; [BENCHMARK | vykonß v²raz tolikrßt, kolik udßvß argument poΦet. Vracφ v₧dy hodnotu 0.] BENCHMARK(%count%, %expr%)º ; [BIN | vracφ binßrnφ hodnotu argumentu X, kde X je hodnota typu BIGINT. Funkce vracφ textov² °et∞zec] BIN(%x%)º ; [BIT_AND | Returns the bitwise AND of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision] BIT_AND(%expr%)º ; [BIT_COUNT | returns the number of bits that are set in the argument N] BIT_COUNT(º|) ; [BIT_OR | Returns the bitwise OR of all bits in expr. The calculation is performed with 64-bit (BIGINT) precision] BIT_OR(%expr%)º ; [CASE value | returns the result where value=compare-value] CASE |value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END ; [CASE when | returns the result for the first condition, which is true] CASE WHEN [|condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END ; [CEILING | vracφ nejmenÜφ celoΦφselnou hodnotu v∞tÜφ nebo rovnou X. Nßvratovß hodnota je p°evedena na hodnotu typu BIGINT] CEILING(%x%) ; [COALESCE | vracφ prvnφ hodnotu p°edanou v zadan²ch v²razech, kterß nenφ prßzdnß] COALESCE(|NULL, X, Y) ; [CONCAT | vracφ v²sledek slouΦenφm argument∙ do jednoho °et∞zce] CONCAT("|", "", "") ; [CONCAT_WS | the first argument is the separator for the rest of the arguments] CONCAT_WS(|separator, str1, str2,...) ; [CONNECTION_ID | returns the connection id (thread_id) for the connection] CONNECTION_ID() ; [CONV | p°evßdφ Φφslo z jednΘ soustavy do druhΘ. V²slednou hodnotou je textov² °et∞zec] CONV(|X, from_base, to_base) ; [COS | vracφ kosinus argumentu X, kde X je vyjßd°eno v radißnech] COS(%x%) ; [COT | vracφ kotangens argumentu X] COT(%x%) ; [COUNT | vracφ poΦet neprßzdn²ch hodnot v²slednΘ sady. Pou₧ijete-li hv∞zdiΦku, vrßtφ poΦet zßznam∙ v²slednΘ sady] COUNT(|º) ; [CREATE DATABASE | vytvo°it databßzi] CREATE DATABASE %IFNOTEXISTS% %named% ; [CREATE INDEX | CREATE INDEX index_name ON tbl_name] CREATE |[UNIQUE|FULLTEXT] INDEX %namei% ON %namet% (col_name[(length)],... ) ; [CREATE TABLE | vytvo°it tabulku] CREATE |[TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] ; [CURDATE | vracφ aktußlnφ systΘmovΘ datum] CURDATE() ; [CURRENT_DATE | vrßtφ dneÜnφ datum jako 'YYYY-MM-DD' nebo YYYYMMDD] CURRENT_DATE() ; [CURRENT_TIME | vrßtφ aktußlnφ systΘmov² Φas jako 'HH:MM:SS' nebo HHMMSS] CURRENT_TIME() ; [CURRENT_TIMESTAMP | vracφ aktußlnφ datum a Φas] CURRENT_TIMESTAMP() ; [CURTIME | vrßtφ aktußlnφ systΘmov² Φas jako 'HH:MM:SS' nebo HHMMSS] CURTIME() ; [DATABASE | vracφ nßzev pracovnφ (aktußlnφ) databßze] DATABASE() ; [DATE_ADD | function perform date arithmetic] DATE_ADD(%datep%, INTERVAL | %interval%) ; [DATE_FORMAT | formßtuje datum na zßklad∞ uvedenΘho symbolu formßtovßnφ] DATE_FORMAT(%datep%, %dformat%) %helpSF% ; [DATE_SUB | odΦφtß hodnotu od zadanΘho data. KlφΦovΘ slovo je nezbytnΘ a musφte je v tΘto funkci pou₧φt] DATE_SUB(%datep%, INTERVAL | %interval%) ; [DT | datov² typ] %type% ; [DAYNAME | vracφ anglick² nßzev dne podle zadanΘho data] DAYNAME(%datep%) ; [DAYOFMONTH | vracφ den v m∞sφci] DAYOFMONTH(%datep%) ; [DAYOFWEEK | vracφ index dne v t²dnu (1 - ned∞le a₧ 7 - sobota)] DAYOFWEEK(%datep%) ; [DAYOFYEAR | vracφ den v roku podle julißnskΘho kalendß°e (1 a₧ 366)] DAYOFYEAR(%datep%) ; [DECODE | vracφ dek≤dovanou verzi binßrnφho °et∞zce. Musφte ovÜem pou₧φt stejn² Üifrovacφ klφΦ jako p°i Üifrovßnφ p∙vodnφho textu] DECODE(crypt_str, pass_str) ; [DELETE | vymazat zßznam z tabulky...] DELETE |[LOW_PRIORITY] FROM tbl_name [WHERE where_definition] [LIMIT rows] ; [DEGREES | vracφ zadanou hodnotu v radißnech jako stupn∞] DEGREES(|º) ; [DESCRIBE | zobrazit seznam sloupc∙ z tabulky...] DESCRIBE %namet%; ; [DROP DATABASE | odstranit celou databßzi] DROP DATABASE %IFEXISTS% %named% ; [DROP INDEX | odstranit INDEX z tabulky...] DROP INDEX %namei% ON %namet% ; [DROP TABLE | odstranit tabulku] DROP TABLE %IFEXISTS% %namet% [, tbl_name,...] [RESTRICT | CASCADE] ; [ELT | vracφ °et∞zec, jeho₧ pozici v seznamu argument∙ urΦuje argument X] ELT(|X, "str1", "str2", "str3",...) ; [ENCODE | vracφ zaÜifrovan² binßrnφ °et∞zec zalo₧en² na Üifrovacφm °et∞zci] ENCODE('|str', 'pass_str') ; [ENCRYPT | vracφ Üifrovan² °et∞zec. Pou₧φvß unixovou funkci crypt(). Nepovinnou poΦßteΦnφ hodnotou m∙₧e b²t dvouznakov² textov² °et∞zec.] ENCRYPT('|str'[ ,'salt']) ; [EXP | vracφ zßklad p°irozenΘho logaritmu umocn∞n² zadan²m argumentem] EXP(|º) ; [EXPORT_SET | returns a string frm set separated with 'separator'] EXPORT_SET(|bits,on,off,[separator,[number_of_bits]]) ; [EXTRACT | vracφ vybranou hodnotu na zßklad∞ zadnΘho data] EXTRACT(%typee% FROM %datep%) ; [FIELD | vrßtφ pozici v seznamu argument∙, na nφ₧ se nachßzφ argument, jeho₧ hodnota se shoduje s hodnotou argumentu X] FIELD(|str,str1, str2, str3,...) ; [FIND_IN_SET | returns a value 1 to N if the string str is in the list strlist consisting of N substrings] FIND_IN_SET(|str, strlist) ; [FLOOR | vracφ nejvyÜÜφ mo₧nou celoΦφselnou hodnotu, kterß je menÜφ ne₧ zadanß hodnota. V²slednß hodnota je p°evedena na datov² typ BIGINT] FLOOR(|º) ; [FORMAT | vracφ Φφslo zadanΘ argumentem X ve formßtu çx, xxx, xxx.xç zaokrouhlenΘ na poΦet desetin²ch mφst urΦen²ch v argumentu Y] FORMAT(%x%, %y%) ; [FROM_DAYS | vrßtφ datum na zßklad∞ zadanΘho poΦtu dnφ od poΦßtku naÜeho letopoΦtu] FROM_DAYS(|º) ; [FROM_UNIXTIME | vracφ datum na zßklad∞ systΘmovΘho Φasu v systΘmu UNIX ] FROM_UNIXTIME(|unix_timestamp) ; [FROM_UNIXTIMEf | vracφ datum na zßklad∞ systΘmovΘho Φasu v systΘmu UNIX s mo₧nostφ formßtovßnφ v²sledku] FROM_UNIXTIME(|unix_timestamp, %dformat%) %helpSF% ; [GET_LOCK | ] GET_LOCK(str,timeout) ; [GREATEST | vracφ argument s nejvyÜÜφ hodnotou] GREATEST(|X, Y,...) ; [HOUR | vracφ hodinu ze zadanΘho Φasu] HOUR(%time%) ; [IF | Je-li v²raz1 pravda, vrßtφ funkce v²raz2. Je-li ovÜem v²raz1 nepravda, bude vrßcen v²raz3] IF(%expr1%, %expr2%, %expr3%) ; [IFNULL | obsahuje-li v²raz1 prßzdnou hodnotu, vrßtφ funkce v²raz2. V opaΦnΘm p°φpad∞ je vrßcen v²raz1] IFNULL(%expr1%, %expr2%) ; [INET_NTOA | returns the network address (4 or 8 byte) for the numeric expression] INET_NTOA(%expr%) ; [INET_ATON | returns integer that represents numeric value for network address] INET_ATON(%expr%) ; [INSERT | vracφ °et∞zec X, v n∞m₧ hodnota argumentu J nahrazuje vÜechna Z znak∙ poΦφnaje znakem na pozici Y] INSERT(|X, Y, Z, J) ; [INSERT_select | p°φkazovß syntaxe pro INSERT] INSERT |[LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] SELECT ... ; [INSERT_set | p°φkazovß syntaxe pro INSERT] INSERT |[LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name SET col_name=expression, col_name=expression, ... ; [INSERT_values | p°φkazovß syntaxe pro INSERT] INSERT |[LOW_PRIORITY | DELAYED] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES (expression,...),(...),... ; [INSTR | vracφ pozici znaku Y v °et∞zci X] INSTR(|X, Y) ; [ISNULL | vracφ 1, je-li zadan² v²raz vyhodnocen jako NULL. V opaΦnΘm p°φpad∞ vracφ nulu] ISNULL(%expr%) ; [HEX | vracφ hexadecimßlnφ hodnotu argumentu X, kde X je hodnotou typu BIGINT. Funkce vracφ textovou hodnotu] HEX(%x%) ; [CHAR | vracφ °et∞zec hodnot zalo₧en²ch na k≤dech ASCII. PrßzdnΘ hodnoty jsou ignorovßny] CHAR(|X, Y, Z...) ; [CHAR_LENGTH | vracφ dΘlku °et∞zce] CHAR_LENGTH("|º") ; [CHARACTER_LENGTH | vracφ dΘlku °et∞zce] CHARACTER_LENGTH("|º") ; [LAST_INSERT_ID | vracφ nejvyÜÜφ vlo₧enΘ Φφslo do pole typu AUTO_INCREMENT. V²slednß hodnota je zßvislß na aktußlnφm p°ipojenφ] LAST_INSERT_ID(%expr%) ; [LCASE | p°evede °et∞zec na malß pφsmena] LCASE("|º") ; [LEAST | vracφ argument s nejni₧Üφ hodnotou (celß Φφsla jsou porovnßvßna jako celß Φφsla, °et∞zce s ohledem na velikost pφsmenek)] LEAST(|X, Y, Z...) ; [LEFT | vracφ index argumentu Y v °et∞zci X poΦφtßno zleva] LEFT(|X, Y) ; [LENGTH | vracφ dΘlku °et∞zce] LENGTH("|º") ; [LOAD_DATA_INFILE | syntaxe] LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)] ; [LOAD_FILE | p°eΦte soubor a vrßtφ obsah souboru jako °et∞zec. Soubor musφ b²t ulo₧en na serveru a u₧ivatel musφ mφt p°id∞lenß privilegia FILE] LOAD_FILE(%file%) ; [LOCATE | returns the position of the first occurrence of substring] LOCATE(|substr,str,pos) ; [LOCATE2 | returns the position of the first occurrence of substring] LOCATE(|substr,str) ; [LOCK TABLES | LOCK TABLES tbl_name] LOCK TABLES %namet% [AS alias] {READ | [READ LOCAL] | [LOW_PRIORITY] WRITE} [, tbl_name {READ | [LOW_PRIORITY] WRITE} ...] ; [LOG | vrßtφ p°irozen² logaritmus zadanΘ hodnoty] LOG(|º) ; [LOG10 | vrßtφ logaritmus od zßkladu 10] LOG10(|º) ; [LOWER | p°evede °et∞zec na malß pφsmena] LOWER("|º") ; [LPAD | vracφ °et∞zec X dopln∞n² zleva °et∞zcem Z tak, aby se celkovß dΘlka v²slednΘho °et∞zce rovnala Y] LPAD(|X, Y, Z) ; [LTRIM | vracφ °et∞zec X bez vedoucφch mezer] LTRIM("|º") ; [MAKE_SET | returns a set consisting of the strings] MAKE_SET(|bits, str1, str2,...) ; [MASTER_POS_WAIT | blocks until slave reaches specified position in master log] MASTER_POS_WAIT(|log_name, log_pos) ; [MATCH | is used for full-text search and returns relevance] MATCH (|col1,col2,...) AGAINST (%expr%) ; [MD5 | VypoΦφtß MD5 128 bitov² kontrolnφ souΦet pro °et∞zec] MD5(|string) ; [MID | vracφ °et∞zec Z znak∙ z °et∞zce X, poΦφnaje znakem na pozici Y] MID(|X, Y, Z) ; [MIN | vracφ nejmenÜφ hodnotu zadanΘho v²razu] MIN(%expr%) ; [MINUTE | vracφ minutu ze zadanΘho Φasu] MINUTE(%time%) ; [MOD | vracφ zbytek po d∞lenφ d∞lence X d∞litelem Y. M∙₧ete pou₧φt i symbol %] MOD(%x%, %y%) ; [MONTH | vracφ index m∞sφce podle zadanΘho data] MONTH(%datep%) ; [MONTHNAME | vracφ anglick² nßzev m∞sφce podle zadanΘho data] MONTHNAME(%datep%) ; [NOW | vracφ aktußlnφ datum a Φas] NOW(|º) ; [OCT | vracφ osmiΦkovou hodnotu argumentu X, kde X je hodnota typu BIGINT. Funkce vracφ textov² °et∞zec] OCT(%x%) ; [OCTET_LENGTH | vracφ dΘlku °et∞zce] OCTET_LENGTH("|º") ; [ORD | vracφ ASCII k≤dovou hodnotu znaku] ORD("|º") ; [PASSWORD | vracφ zaÜifrovan² °et∞zec zadanΘho textu] PASSWORD("|º") ; [PERIOD_ADD | vracφ hodnotu, je₧ je souΦtem Y m∞sφc∙ p°idan²ch k obdobφ X. Argument X nenφ hodnotou typu datum] PERIOD_ADD(|X, Y) ; [PERIOD_DIFF | vracφ poΦet m∞sφc∙ mezi X a Y. Argumenty X a Y by m∞li b²t ve formßtu YYMM nebo CCYYMM] PERIOD_DIFF(%x%, %y%) ; [PI | vracφ hodnotu Ludolfova Φφsla] PI()º ; [POSITION | vracφ pozici prvnφho v²skytu znaku X v °et∞zci Y. Nenφ-li znak nalezen, vracφ funkce nulu] POSITION(|X, Y) ; [POW | vracφ v²sledek argumentu X umocn∞nΘho argumentem Y] POW(|X, Y) ; [POWER | vracφ v²sledek argumentu X umocn∞nΘho argumentem Y] POWER(%x%, %y%) ; [QUARTER | vracφ Φtvrtletφ podle zadanΘho data (1-4)] QUARTER(%datep%) ; [RADIANS | vracφ hodnotu v radißnech podle vlo₧enΘho argumentu zadanΘho ve stupnφch] RADIANS(|º) ; [RAND | vracφ pseudonßhodnΘ Φφslo s plovoucφ Φßrkou v intervalu 0-1. Je-li uveden argument, je pou₧it jako poΦßteΦnφ (odrazovß) hodnota] RAND(|º) ; [RELEASE_LOCK | releases the lock named by the string str] RELEASE_LOCK("|º") ; [RENAME TABLE | p°ejmenovat tabulku(ky) na...] RENAME TABLE %namet% TO %nament%[, %namet2% TO %nament2%,...] ; [REPEAT | vracφ °et∞zec X, opakovan² Y krßt. Je-li Y menÜφ ne₧ nula, vracφ funkce prßzdn² °et∞zec ] REPEAT(|X, %y%) ; [REPLACE | vracφ °et∞zec X, v n∞m₧ jsou vÜechny v²skyty Y nahrazeny obsahem argumentu Z.] REPLACE(|X, Y, Z) ; [REPLACE select | p°φkazovß syntaxe pro nahrazenφ] REPLACE |[LOW_PRIORITY | DELAYED] [INTO] tbl_name [(col_name,...)] SELECT ... ; [REPLACE set | p°φkazovß syntaxe pro nahrazenφ ] REPLACE |[LOW_PRIORITY | DELAYED] [INTO] tbl_name SET col_name=expression, col_name=expression,... ; [REPLACE values | p°φkazovß syntaxe pro nahrazenφ] REPLACE |[LOW_PRIORITY | DELAYED] [INTO] tbl_name [(col_name,...)] VALUES (expression,...) ; [REVERSE | vracφ °et∞zec v obrßcenΘm po°adφ] REVERSE("|º") ; [RIGHT | vracφ skupinu znak∙ zprava o dΘlce X z °et∞zce Y. Obsahuje-li Y hodnotu NULL, vrßtφ funkce prßzdnou hodnotu] RIGHT(|X, Y) ; [ROUND | vracφ zadan² argument zaokrouhlen² na nejbli₧Üφ celΘ Φφslo] ROUND(º|) ; [ROUND | vracφ argument X zaokrouhlen² na urΦit² poΦet desetin²ch mφst] ROUND(%x%, %count%) [RPAD | vracφ °et∞zec X dopln∞n² zprava °et∞zcem Z tak, aby se celkovß dΘlka v²slednΘho °et∞zce rovnala Y] RPAD(X, Y, Z) ; [RTRIM | vracφ °et∞zec bez koncov²ch mezer] RTRIM("|º") ; [SEC_TO_TIME | vracφ Φas ve formßtu hh:mm:ss odvozen² z poΦtu sekund zadan²ch prost°ednictvφm argumentu] SEC_TO_TIME(%seconds%) ; [SECOND | vracφ sekundy ze zadanΘho Φasu] SECOND(%time%) ; [SELECT | p°φkazovß syntaxe pro SELECT ] SELECT |[STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] select_expression,... [INTO {OUTFILE | DUMPFILE} '%file%' export_options] [FROM table_references [WHERE where_definition] [GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...] [HAVING where_definition] [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...] [LIMIT [offset,] rows] [PROCEDURE procedure_name] [FOR UPDATE | LOCK IN SHARE MODE]] ; [SESSION_USER | vracφ u₧ivatele aktußlnφho p°ipojenφ] SESSION_USER() ; [SET TRANSACTION LEVEL | set transaction isolation level] SET |[GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL [READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE] ; [SIGN | vrßtφ znamΘnko argumentu jako -1, 0, nebo 1, v zßvislosti na tom zda zadanß hodnota je negativnφ, nulovß, nebo pozitivnφ] SIGN(|º) ; [SIN | vracφ sinus argumentu X, kde X je hodnota uvedenß v radißnech] SIN(%x%) ; [SHOWc | zobrazit seznam sloupc∙ z tabulky...] SHOW COLUMNS FROM %namet%; ; [SHOWd | zobrazit seznam dostupn²ch databßzφ] SHOW DATABASES; ; [SHOWt | zobrazit seznam tabulek v databßzi] SHOW TABLES; ; [SHOWtf | zobrazit seznam tabulek z databßze...] SHOW TABLES FROM %named%; ; [SOUNDEX | vracφ °et∞zec soundex na zßklad∞ zadanΘho argumentu] SOUNDEX("|º") ; [SPACE | vracφ °et∞zec slo₧en² z X mezer] SPACE(%count%) ; [SQRT | vracφ druhou odmocninu zadanΘho parametru] SQRT(|º) ; [STRCMP | returns 0 if strings are same, -1 if first is smaller, 1 otherwise] STRCMP(%expr1%, %expr2%) ; [SUBDATE | odΦφtß hodnotu od zadanΘho data. KlφΦovΘ slovo je nezbytnΘ a musφte je v tΘto funkci pou₧φt] SUBDATE(%datep%, INTERVAL | %interval%) ; [SUBSTRING | vracφ pod°et∞zec, nachßzejφcφ se v °et∞zci X, za Z v²skyty °et∞zce Y. Je-li Y kladnß hodnota, vrßtφ funkce vÜe, co je vlevo od poslednφho vrßcenΘho odd∞lovaΦe. V opaΦnΘm p°φpad∞ je vrßcen pod°et∞zec od odd∞lovaΦe napravo] SUBSTRING(|X, Y, Z) ; [SUBSTRING | returns a substring from string str, starting at position pos] SUBSTRING(|str FROM pos FOR len) ; [SUBSTRING | returns a substring from string str, starting at position pos] SUBSTRING(|str,pos) ; [SUBSTRING | returns a substring from string str starting at position pos] SUBSTRING(|str FROM pos) ; [SUBSTRING_INDEX | returns the substring from string str before count occurrences of the delimiter delim] SUBSTRING_INDEX(|str, delim, %count%) ; [STD | vracφ standardnφ odchylku zadanΘho v²razu. Tato funkce pou₧φvß pouze neprßzdnΘ hodnoty] STD(%expr%) ; [STDDEV | vracφ standardnφ odchylku zadanΘho v²razu. Tato funkce pou₧φvß pouze neprßzdnΘ hodnoty] STDDEF(%expr%) ; [STRCMP | vracφ hodnotu 1, pokud se °et∞zec1 shoduje se °et∞zcem °et∞zec2. Pokud se liÜφ, vracφ nulu.] STRCMP(str1, str2) ; [SUM | vracφ souΦet zadanΘho v²razu. Tato funkce pou₧φvß pouze neprßzdnΘ hodnoty] SUM(%expr%) ; [SYSDATE | vracφ aktußlnφ datum a Φas] SYSDATE() ; [SYSTEM_USER | vracφ u₧ivatele aktußlnφho p°ipojenφ] SYSTEM_USER() ; [TAN | vracφ tangentu zadanΘho argumentu uvedenΘho v radißnech] TAN(|º) ; [TIME_FORMAT | vracφ Φas v zadanΘm formßtu] TIME_FORMAT(%time%, %dformat%) %helpSF% ; [TIME_TO_SEC | vracφ poΦet sekund od p∙lnoci podle zadanΘho Φasu] TIME_TO_SEC(%time%) ; [TO_DAYS | vracφ poΦet dnφ od poΦßtku letopoΦtu] TO_DAYS(%datep%) ; [TRIM | returns the string str with all remstr prefixes and/or suffixes removed] TRIM(|[[BOTH | LEADING | TRAILING] [remstr] FROM] str) ; [TRUNCATE TABLE | TRUNCATE TABLE command syntax] TRUNCATE TABLE %namet% ; [TRUNCATE | vracφ argument X bez Y odseknut²ch desetin²ch mφst. Pokud se Y rovnß nule, bude vrßcena jen celoΦφselnß Φßst argumentu] TRUNCATE(%x%, %y%) ; [UCASE | P°evede °et∞zec na velkß pφsmena] UCASE("|º") ; [UNLOCK TABLES | UNLOCK TABLES locked previous LOCK TABLE command] UNLOCK TABLES ; [UNIX_TIMESTAMP | vracφ Φasovou znaΦku systΘmu unix] UNIX_TIMESTAMP() ; [UNIX_TIMESTAMPd | vracφ datum jako Φasovou znaΦku systΘmu unix] UNIX_TIMESTAMP(%datep%) ; [UPDATE | p°φkazovß syntaxe pro UPDATE] UPDATE |[LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #] ; [UPPER | p°evede °et∞zec na velkß pφsmena] UPPER("|º") ; [USE | pou₧φt databßzi...] USE %named% ; [USER | vracφ jmΘno u₧ivatele aktußlnφho p°ipojenφ] USER() ; [VERSION | vracφ verzi serveru jako textov² °et∞zec] VERSION() ; [WEEK | vracφ Φφslo t²dne podle zadanΘho data. Nepovinn² argument start urΦuje poΦßteΦnφ index dne v t²dnu (0 Ned∞le, 1 pond∞lφ)] WEEK(%datep%%start%) ; [WEEKDAY | vracφ index dne v t²dnu na zßklad∞ zadanΘho data. (0 = pond∞lφ)] WEEKDAY(%datep%) ; [YEAR | ze zadanΘho data extrahuje rok] YEAR(%datep%) ; [YEARWEEK | vracφ rok a t²den ze zadanΘho data] YEARWEEK(%datep%) ; [YEARWEEKf | vracφ rok a t²den ze zadanΘho data] YEARWEEK(%datep%%start%) ; ;--------------------------------------------------------------------- ; Mo₧nosti jazyka ;--------------------------------------------------------------------- [Tree Content] Srovnßnφ GREATEST IF IFNULL INTERVAL ISNULL LEAST NULLIF STRCMP Matematika ABS ACOS ASIN ATAN ATAN2 CEILING COS COT DEGREES EXP FLOOR LOG LOG10 MOD PI POW POWER RADIANS RAND ROUND SIGN SIN SQRT TAN TRUNCATE ╪et∞zce ASCII BIN CHAR CHARACTER_LENGTH CHAR_LENGTH COALESCE CONCAT CONCAT_WS CONV ELT EXPORT_SET FIELD FIND_IN_SET FORMAT HEX INSERT INSERT_select INSERT_set INSERT_values INSTR LCASE LEFT LENGTH LOCATE LOWER LPAD LTRIM MAKE_SET MID OCT OCTET_LENGTH ORD POSITION REPEAT REPLACE REVERSE RIGHT RPAD RTRIM SOUNDEX SPACE SUBSTRING SUBSTRING_INDEX TRIM UCASE UPPER Datum a Φas ADDDATE CURDATE CURTIME DATE_ADD DATE_FORMAT DATE_SUB DAYNAME DAYOFMONTH DAYOFWEEK DAYOFYEAR EXTRACT FROM_DAYS FROM_UNIXTIME HOUR MINUTE MONTH MONTHNAME NOW PERIOD_ADD PERIOD_DIFF QUARTER SECOND SEC_TO_TIME SUBDATE SYSDATE TIME_FORMAT TIME_TO_SEC TO_DAYS UNIX_TIMESTAMP UNIX_TIMESTAMPd WEEK WEEKDAY YEAR YEARWEEK YEARWEEKf Shrnovßnφ AVG BIT_AND BIT_OR COUNT MAX MIN STD STDDEV SUM RozmanitΘ BENCHMARK BIT_COUNT CONNECTION_ID DECODE ENCODE GET_LOCK INET_NTOA INET_ATON LOAD_DATA_INFILE LOAD_FILE RELEASE_LOCK SytΘmovΘ funkce DATABASE ENCRYPT LAST_INSERT_ID MD5 PASSWORD SESSION_USER SYSTEM_USER USER VERSION ; [Keywords] ABS() ACOS() ADDDATE() ALL ALTER ASC ASCII() ASIN() ATAN() ATAN2() AVG() BENCHMARK() BIN() BIT_AND() BIT_COUNT() BIT_OR() CASE CEILING() COALESCE() CONCAT() CONCAT_WS() CONNECTION_ID() CONV() COS() COT() COUNT() CREATE CURDATE() CURTIME() DATABASE() DATE_ADD() DATE_FORMAT() DATE_SUB() DAYNAME() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DECODE() DEGREES() DELAYED DELETE DESC DESCRIBE DISTINCT DISTINCTROW DROP DUMPFILE ELT() ENCODE() ENCRYPT() EXP() EXPORT_SET() EXTRACT() FIELD() FIND_IN_SET() FLOOR() FORMAT() FROM FROM_DAYS() FROM_UNIXTIME() GET_LOCK() GREATEST() HEX() HIGH_PRIORITY HOUR() CHAR() CHAR_LENGTH() CHARACTER_LENGTH() IF EXISTS IF NOT EXISTS IF() IFNULL() INET_ATON() INET_NTOA() INSERT INSTR() INTERVAL INTO ISNULL() LAST_INSERT_ID() LCASE() LEADING LEAST() LEFT() LENGTH() LIMIT LOAD_DATA_INFILE LOAD_FILE() LOCATE() LOCK LOG() LOG10() LOW_PRIORITY LOWER() LPAD() LTRIM() MAKE_SET() MAX() MD5() MID() MIN() MINUTE() MOD() MONTH() MONTHNAME() NOW() NULLIF OCT() OCTET_LENGTH() ORD() OUTFILE PASSWORD() PERIOD_ADD() PERIOD_DIFF() PI() POSITION() POW() POWER() PROCEDURE QUARTER() RADIANS() RAND() READ COMMITTED READ LOCAL READ UNCOMMITTED RELEASE_LOCK() REPEAT() REPEATABLE READ REPLACE REPLACE() REVERSE() RIGHT() ROUND() RPAD() RTRIM() SEC_TO_TIME() SECOND() SELECT SERIALIZABLE SESSION SESSION_USER() SET SHOW SIGN() SIN() SOUNDEX() SPACE() SQL_BIG_RESULT SQL_BUFFER_RESULT SQL_SMALL_RESULT SQRT() STD() STDDEV() STRAIGHT_JOIN STRCMP() SUBDATE() SUBSTRING() SUBSTRING_INDEX() SUM() SYSDATE() SYSTEM_USER() TABLE TAN() TEMPORARY TIME_FORMAT() TIME_TO_SEC() TO_DAYS() TRAILING TRANSACTION ISOLATION LEVEL TRIM() TRUNCATE TRUNCATE() UCASE() UNIX_TIMESTAMP() UNLOCK UPDATE UPPER() USE USER() VALUES VERSION() WEEK() WEEKDAY() WHERE WRITE YEAR() YEARWEEK() ; 
